PARTITION RANGE
Short Description
This indicated RANGE PARTITIONS are being accessed. Partitions accessed after pruning are shown in the PARTITION START and PARTITION STOP columns.
Where to use​
Partitioning is typically used on very large tables and use of the partition keys can allow targeted access to a reduced data set - remember - to make a query go faster - access less data. Partitioned tables can be accessed using parallel query servers. Parallel query servers are great at returning data fast, but be aware of the CPU and disk resource usage as in a multi user system, resources can be exhausted very quickly.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.